SELECT
Addr,
reverse(left(reverse(Addr), charindex('\', reverse(Addr)) -1)) AS FileName
FROM myTbl
Addr,
reverse(left(reverse(Addr), charindex('\', reverse(Addr)) -1)) AS FileName
FROM myTbl
سید حامد واحدی
1 مهر 1395